package com.example.dao;

import com.example.entity.increase;
import java.util.List;
import java.sql.SQLException;

public interface increaseDao extends Dao {

    // 判断数据是否存在
    boolean existsByName(String name) throws SQLException;

    // 插入数据
    boolean insertIncreaseData(increase item) throws SQLException;

    // 获取今日按金额排序的数据
    List<increase> getTodayIncreaseByAmount() throws SQLException;

    // 获取昨日按金额排序的数据
    List<increase> getYesterdayIncreaseByAmount() throws SQLException;

    // 获取本周按金额排序的数据
    List<increase> getThisWeekIncreaseByAmount() throws SQLException;

    // 获取本月按金额排序的数据
    List<increase> getThisMonthIncreaseByAmount() throws SQLException;

    // 获取今日按百分比排序的数据
    List<increase> getTodayIncreaseByPercentage() throws SQLException;

    // 获取昨日按百分比排序的数据
    List<increase> getYesterdayIncreaseByPercentage() throws SQLException;

    // 获取本周按百分比排序的数据
    List<increase> getThisWeekIncreaseByPercentage() throws SQLException;

    // 获取本月按百分比排序的数据
    List<increase> getThisMonthIncreaseByPercentage() throws SQLException;
}
